Redshift Data source

Please enter the following parameters to connect to a Redshift data source:

• Alias: name of the data source to be used in CData Virtuality Server
• Host / Port: IP address or hostname and port of the server where the data source is running
• SSL: use encrypted connection (available for Redshift data source)
• Schema / Database : schema / database name of the Redshift data source to connect to
• User name / Password: credentials to connect to data source
• Data source parameters: additional connection parameters
• Translator parameters: additional translator parameters
• JDBC parameters: additional JDBC parameters

Below are some examples of the most common data source parameters, see the reference manual for the full list:

• importer.useFullSchemaName=TRUE - schema names will be prefixed to table names to avoid duplicates

AWS S3 Load Options will set the credentials for using AWS S3:

• S3 Key ID: ID of the key which has proper permission to access the S3 bucket
• S3 Secret Key: secret key used to access the S3 bucket
• S3 Bucket Name : name of the S3 bucket to access
• S3 Region: region which the S3 bucket is located

To test the connection parameters press the Test connection button.